![]() |
![]() |
Connecting to SQL Server
2005 Analysis Services over HTTP protocol
Requirements:
HTTP
access to SQL Server 2005 Analysis Services has successfully been configured on
a windows server.
You
have been given access rights to connect to the server (depends on the server
configured security settings)
1.
URL
address
In
order to connect to AS over http you must know the „path“
– that is the URL address for the connection
to be
established.
This
URL address maps to the AS pump component loaded into IIS (Internet Information
Services) on some
windows server
and serves as an ISAPI extension, pumping data from the client to an Analysis
Services
server and
back. Depending on the server configuration the HTTP pump can reside on a
different server
than the
Analysis Services server you will be using as the data source.
Enter
the path to your virtual directory concatenated with “msmdpump.dll” in the
server text box.
2.
Identification
CubePlayer's
connect dialog supports different types of authentication:
·
Anonymous
·
Basic
(provide username and password in the provided text boxes)
·
Integrated (use the check box)
The
type of authentication and possibly the credentials that you may have to provide
to identify yourself
depend on the
server configured security settings (and/or your location – intranet, VPN, www).
Contact
the server administrator to find out what type of authentication is
required.
Example
for integrated security (the LAN scenario):
Your
administrator has configured HTTP access to SQL Server 2005 Analysis Services on
a company server named „BI_SERVER“ in the virtual directory „AS2005“.
In
order to minimize potential security issues the administrator has restricted the
authentication to integrated security only.
To
connect to the server from CubePlayer, you should enter the path to your virtual
directory concatenated with “msmdpump.dll” in the server text box that is
„http://BI_SERVER/AS2005/msmdpump.dll“ and check the
Integrated security checkbox.